Forces every formula in the open workbook to be recalculated.
expression.CalculateFull
expression Required. An expression that returns a Spreadsheet object.
This example forces a full calculation of all data in Spreadsheet1.
Spreadsheet1.CalculateFull